package com.example.demo.DAO;

import com.example.demo.DO.ShopDO;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ShopDAO {
    @Select("select * from shop1")
    public List<ShopDO> selectAll();
    @Insert("insert into shop1 value (#{aucId},#{gostart},#{goend},#{aucPrice})")
    public int insert(String aucId,String gostart,String goend,Double aucPrice);
    @Delete("delete from shop1 where aucId=#{aucId}")
    public int delete(String aucId);
    @Select("select aucPrice from shop1 where aucId=#{aucId};")
    public Double selectPrice(String aucId);
    @Select("select * from shop1 where aucId=#{aucId}")
    public List<ShopDO> selectId(String aucId);
}